This reading will give you an overview of the Data Analytics module.

Scenario: You are a data engineer at an e-commerce company. Your company has finished setting up a data warehouse. Now you are assigned the responsibility to design a reporting dashboard that reflects the key metrics of the business.

This assignment can be completed using either one of the following two options:

1. (Optional): Final Assignment : Dashboard Creation using IBM Cognos Analytics (or)

2. (Optional): Final Assignment : Dashboard Creation using Google Looker Studio

You will perform a couple of exercises with multiple tasks. But before proceeding with the assignment, ensure that you have access to IBM Cognos Analytics (or) Google Looker Studio. Once you have access to either of these, download the data from the provided link.

The first exercise requires you to load data from the downloaded CSV file into a table and then list the first ten rows in the table. In the second exercise, you will create a data source in IBM Cognos Analytics (or) Google Looker Studio. In the final exercise, you will create a dashboard by performing tasks such as creating a bar chart of quarterly sales of mobile phones, a pie chart of category-wise sales of electronic goods, and a line chart of month-wise total sales for a given year. After completing each task, take a screenshot of the command you used and the output you obtained. Also, give a name to each screenshot. Good luck, and let’s get started!